#!/usr/bin/env python
# -*- coding:utf-8 -*-
# **
# 参考计算EXCEL原文件中列表左侧的数据列
# 释义 =======> 对应列 =======> 公式
# 年期
# 翌年歲
# 每年供款
# 現金提取
# 入息
# 累積入息
# 退保價值
# 積存
# 入息
# 積存結餘
# 退保價值
class EgiBaseTabLeft:

    def __init__(self):
        return

    EgiBaseTabLeft = {
        "year": 0,
        "anb": 0,
        "annual_contribution": 0,
        "cash_payment_income": 0,
        "cash_payment_cumulative_income": 0,
        "cash_payment_surrender_value": 0,
        "accumulation_income": 0,
        "accumulation_cumulative_income": 0,
        "accumulation_surrender_value": 0,
    }

    # 年期
    Year = 0
    # 翌年歲
    ANB = 0
    # 每年供款
    Annual_Contribution = float(0)
    # 現金提取 Cash Payment
    # 現金提取 入息
    Cash_Payment_Income = float(0)
    # 現金提取 累積入息
    Cash_Payment_Cumulative_Income = float(0)
    # 現金提取 退保價值
    Cash_Payment_Surrender_Value = float(0)
    # 積存 Accumulation
    # 積存 入息
    Accumulation_Income = float(0)
    # 積存 積存結餘
    Accumulation_Cumulative_Income = float(0)
    # 積存 退保價值
    Accumulation_Surrender_Value = float(0)

    # 计算 Annual Contribution
    # Params:
    def get_Annual_Contribution(self):
        return None

    # 计算 Cash Payment Income
    # Params:
    def get_Cash_Payment_Income(self):
        # 参考计算公式
        # =IF($C35<=151,R35+S35+Y35+Z35+AF35+AG35+AM35+AN35+AT35+AU35+BA35+BB35,0)
        return None

    # 计算 Cash Payment Cumulative_Income
    # Params:
    def get_Payment_Cumulative_Income(self):
        # 参考计算公式
        # =IF($C35<=151,F34+E35,0)
        return None

    # 计算 Cash Payment Surrender_Value
    # Params:
    def get_Payment_Surrender_Value(self):
        # 参考计算公式
        # =IF($C35<=151,T35+U35+AA35+AB35+AH35+AI35+AO35+AP35+AV35+AW35+BC35+BD35,0)
        return None

    # 计算 Accumulation Income
    # Params:
    def get_Accumulation_Income(self):
        # 参考计算公式
        # =IF($B35<=10,E35,0)
        return None

    # 计算 Accumulation Cumulative_Income
    # Params:
    def get_Accumulation_Cumulative_Income(self):
        # 参考计算公式
        # =IF($C35<=151,V35+W35+AC35+AD35+AJ35+AK35+AQ35+AR35+AX35+AY35+BE35+BF35,0)
        return None

    # 计算 Accumulation Surrender_Value
    # Params:
    def get_Accumulation_Surrender_Value(self):
        # 参考计算公式
        # =IF($C35<=151,G35+I35,0)
        return None
